Файл: WoWonder 1.2.1/MySQL/WoWonder.sql
Строк: 756
-- phpMyAdmin SQL Dump
-- version 4.2.11
-- http://www.phpmyadmin.net
--
--
Host: localhost
-- Generation Time: Jan 07, 2016 at 06:20 PM
-- Server
version: 5.6.21
-- PHP Version: 5.6.3
SET SQL_MODE =
"NO_AUTO_VALUE_ON_ZERO";
SET time_zone =
"+00:00";
/*!40101 SET
@OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET
@OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET
@OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES
utf8 */;
--
-- Database: `data_old2`
--
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Activities`
--
CREATE TABLE IF NOT EXISTS
`Wo_Activities` (
`id` int(11) NOT NULL,
`user_id` int(255) NOT NULL,
`post_id` int(255) NOT NULL,
`activity_type` varchar(32) NOT NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Ads`
--
CREATE TABLE IF NOT EXISTS `Wo_Ads` (
`id`
int(11) NOT NULL,
`type` varchar(32) CHARACTER SET latin1 NOT NULL,
`code` text CHARACTER SET latin1 NOT NULL,
`active` enum('0','1')
CHARACTER SET latin1 NOT NULL DEFAULT '1'
) ENGINE=InnoDB AUTO_INCREMENT=4
DEFAULT CHARSET=utf8;
--
-- Dumping data for table `Wo_Ads`
--
INSERT
INTO `Wo_Ads` (`id`, `type`, `code`, `active`) VALUES
(1, 'header', '',
'0'),
(2, 'sidebar', 'as', '0'),
(4, 'footer', '', '0');
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Albums_Media`
--
CREATE TABLE IF NOT EXISTS
`Wo_Albums_Media` (
`id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`image` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Announcement`
--
CREATE TABLE IF NOT EXISTS
`Wo_Announcement` (
`id` int(11) NOT NULL,
`text` text NOT NULL,
`time`
int(32) NOT NULL,
`active` enum('0','1') NOT NULL DEFAULT '1'
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Announcement_Views`
--
CREATE TABLE IF NOT EXISTS
`Wo_Announcement_Views` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT
NULL,
`announcement_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Apps`
--
CREATE TABLE IF NOT EXISTS `Wo_Apps`
(
`id` int(11) NOT NULL,
`app_user_id` int(11) NOT NULL,
`app_name`
varchar(32) NOT NULL,
`app_website_url` varchar(55) NOT NULL,
`app_description` text NOT NULL,
`app_avatar` varchar(100) NOT NULL
DEFAULT 'upload/photos/app-default-icon.png',
`app_callback_url`
varchar(255) NOT NULL,
`app_id` varchar(32) NOT NULL,
`app_secret`
varchar(55) NOT NULL,
`active` enum('0','1') NOT NULL DEFAULT '1'
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Apps_Permission`
--
CREATE TABLE IF NOT EXISTS
`Wo_Apps_Permission` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT
NULL,
`app_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Banned_Ip`
--
CREATE TABLE IF NOT EXISTS
`Wo_Banned_Ip` (
`id` int(11) NOT NULL,
`ip_address` varchar(32) NOT
NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Blocks`
--
CREATE TABLE IF NOT EXISTS `Wo_Blocks`
(
`id` int(11) NOT NULL,
`block_from` int(11) NOT NULL,
`block_to`
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_CommentLikes`
--
CREATE TABLE IF NOT EXISTS
`Wo_CommentLikes` (
`id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Comments`
--
CREATE TABLE IF NOT EXISTS
`Wo_Comments` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`text` text NOT
NULL,
`c_file` varchar(255) NOT NULL,
`time` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_CommentWonders`
--
CREATE TABLE IF NOT EXISTS
`Wo_CommentWonders` (
`id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`comment_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Comment_Replies`
--
CREATE TABLE IF NOT EXISTS
`Wo_Comment_Replies` (
`id` int(11) NOT NULL,
`comment_id` int(11) NOT
NULL,
`user_id` int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`text`
text NOT NULL,
`time` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Comment_Replies_Likes`
--
CREATE TABLE IF NOT
EXISTS `Wo_Comment_Replies_Likes` (
`id` int(11) NOT NULL,
`reply_id`
int(11) NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Comment_Replies_Wonders`
--
CREATE TABLE IF NOT
EXISTS `Wo_Comment_Replies_Wonders` (
`id` int(11) NOT NULL,
`reply_id`
int(11) NOT NULL,
`user_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Config`
--
CREATE TABLE IF NOT EXISTS `Wo_Config`
(
`id` int(11) NOT NULL,
`name` varchar(100) NOT NULL,
`value`
varchar(1000) NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT
CHARSET=utf8;
--
-- Dumping data for table `Wo_Config`
--
INSERT INTO
`Wo_Config` (`id`, `name`, `value`) VALUES
(1, 'siteName', 'WoWonder'),
(2,
'siteTitle', 'WoWonder Social Network Platform'),
(3, 'siteKeywords',
'social, wowonder, social site'),
(4, 'siteDesc', 'WoWonder v1.1 is a
Social Networking Platform. With our new feature, user can wonder posts,
photos,'),
(5, 'siteEmail', 'info@example.com'),
(6, 'defualtLang',
'english'),
(7, 'emailValidation', '0'),
(8, 'emailNotification', '1'),
(9,
'fileSharing', '1'),
(10, 'seoLink', '1'),
(11, 'cacheSystem', '0'),
(12,
'chatSystem', '1'),
(13, 'useSeoFrindly', '1'),
(14, 'reCaptcha',
'0'),
(15, 'reCaptchaKey', ''),
(16, 'user_lastseen', '1'),
(17, 'age',
'1'),
(18, 'deleteAccount', '1'),
(19, 'connectivitySystem', '0'),
(20,
'profileVisit', '1'),
(21, 'maxUpload', '1000000000'),
(22,
'maxCharacters', '320'),
(23, 'message_seen', '1'),
(24, 'message_typing',
'1'),
(25, 'google_map_api',
'AIzaSyBOfpaMO_tMMsuvS2T4zx4llbtsFqMuT9Y'),
(26, 'allowedExtenstion',
'jpg,png,jpeg,gif,docx,zip,rar,pdf,doc,mp3,mp4,wav,txt'),
(27,
'censored_words', ''),
(28, 'googleAnalytics', ''),
(29, 'AllLogin',
'1'),
(30, 'googleLogin', '1'),
(31, 'facebookLogin', '1'),
(32,
'twitterLogin', '1'),
(33, 'linkedinLogin', '1'),
(34, 'VkontakteLogin',
'1'),
(35, 'facebookAppId', ''),
(36, 'facebookAppKey', ''),
(37,
'googleAppId', ''),
(38, 'googleAppKey', ''),
(39, 'twitterAppId',
''),
(40, 'twitterAppKey', ''),
(41, 'linkedinAppId', ''),
(42,
'linkedinAppKey', ''),
(43, 'VkontakteAppId', ''),
(44, 'VkontakteAppKey',
''),
(45, 'theme', 'wowonder'),
(47, 'second_post_button', 'wonder'),
(48,
'instagramAppId', ''),
(49, 'instagramAppkey', ''),
(50, 'instagramLogin',
'1'),
(51, 'header_background', '#444444'),
(52, 'header_hover_border',
'#666666'),
(53, 'header_color', '#ffffff'),
(54, 'body_background',
'#f9f9f9'),
(55, 'btn_color', '#ffffff'),
(56, 'btn_background_color',
'#a84849'),
(57, 'btn_hover_color', '#ffffff'),
(58,
'btn_hover_background_color', '#c45a5b'),
(59, 'setting_header_color',
'#ffffff'),
(60, 'setting_header_background', '#a84849'),
(61,
'setting_active_sidebar_color', '#ffffff'),
(62,
'setting_active_sidebar_background', '#a84849'),
(63,
'setting_sidebar_background', '#ffffff'),
(64, 'setting_sidebar_color',
'#444444'),
(65, 'logo_extension', 'png'),
(66, 'online_sidebar', '1');
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Followers`
--
CREATE TABLE IF NOT EXISTS
`Wo_Followers` (
`id` int(11) NOT NULL,
`following_id` int(11) NOT NULL,
`follower_id` int(11) NOT NULL,
`is_typing` int(11) NOT NULL DEFAULT
'0',
`active` int(255) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Games`
--
CREATE TABLE IF NOT EXISTS `Wo_Games`
(
`id` int(11) NOT NULL,
`game_name` varchar(50) NOT NULL,
`game_avatar` varchar(100) NOT NULL,
`game_link` varchar(100) NOT NULL,
`active` enum('0','1') NOT NULL DEFAULT '1',
`time` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Games_Players`
--
CREATE TABLE IF NOT EXISTS
`Wo_Games_Players` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`game_id` int(11) NOT NULL,
`last_play` int(11) NOT NULL,
`active`
enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT
CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Groups`
--
CREATE TABLE IF NOT EXISTS `Wo_Groups`
(
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`group_name`
varchar(32) NOT NULL,
`group_title` varchar(32) NOT NULL,
`avatar`
varchar(120) NOT NULL DEFAULT 'upload/photos/d-group.jpg ',
`cover`
varchar(120) NOT NULL DEFAULT 'upload/photos/d-cover.jpg ',
`about`
varchar(550) NOT NULL,
`category` int(11) NOT NULL DEFAULT '1',
`privacy` enum('1','2') NOT NULL DEFAULT '1',
`join_privacy`
enum('1','2') NOT NULL DEFAULT '1',
`active` enum('0','1') NOT NULL
DEFAULT '0',
`registered` varchar(32) NOT NULL DEFAULT '0/0000'
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Group_Members`
--
CREATE TABLE IF NOT EXISTS
`Wo_Group_Members` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`time` int(11) NOT NULL,
`active`
enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Hashtags`
--
CREATE TABLE IF NOT EXISTS
`Wo_Hashtags` (
`id` int(11) NOT NULL,
`hash` varchar(255) CHARACTER SET
latin1 NOT NULL,
`tag` varchar(255) NOT NULL,
`last_trend_time`
int(255) NOT NULL,
`trend_use_num` int(255) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Likes`
--
CREATE TABLE IF NOT EXISTS `Wo_Likes`
(
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`post_id` int(11)
NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Messages`
--
CREATE TABLE IF NOT EXISTS
`Wo_Messages` (
`id` int(11) NOT NULL,
`from_id` int(11) NOT NULL,
`to_id` int(11) NOT NULL,
`text` text CHARACTER SET latin1 NOT NULL,
`media` varchar(255) CHARACTER SET latin1 NOT NULL,
`mediaFileName`
varchar(200) NOT NULL,
`mediaFileNames` varchar(200) NOT NULL,
`time`
int(255) NOT NULL,
`seen` int(11) NOT NULL DEFAULT '0',
`timestamp`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Notifications`
--
CREATE TABLE IF NOT EXISTS
`Wo_Notifications` (
`id` int(255) NOT NULL,
`notifier_id` int(255) NOT
NULL,
`recipient_id` int(255) NOT NULL,
`post_id` int(255) NOT NULL,
`page_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`seen_pop`
int(11) NOT NULL,
`type` varchar(255) NOT NULL,
`type2` varchar(32) NOT
NULL,
`text` text NOT NULL,
`url` varchar(255) NOT NULL,
`seen`
int(1) NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
`time` int(255) NOT NULL
) ENGINE=InnoDB
DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Pages`
--
CREATE TABLE IF NOT EXISTS `Wo_Pages`
(
`page_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`page_name`
varchar(32) NOT NULL,
`page_title` varchar(32) NOT NULL,
`page_description` varchar(1000) NOT NULL,
`avatar` varchar(255) NOT NULL
DEFAULT 'upload/photos/d-page.jpg',
`cover` varchar(255) NOT NULL DEFAULT
'upload/photos/d-cover.jpg',
`page_category` int(11) NOT NULL DEFAULT
'1',
`website` varchar(255) NOT NULL,
`facebook` varchar(32) NOT NULL,
`google` varchar(32) NOT NULL,
`vk` varchar(32) NOT NULL,
`twitter`
varchar(32) NOT NULL,
`linkedin` varchar(32) NOT NULL,
`company`
varchar(32) NOT NULL,
`phone` varchar(32) NOT NULL,
`address`
varchar(100) NOT NULL,
`call_action_type` int(11) NOT NULL,
`call_action_type_url` varchar(255) NOT NULL,
`instgram` varchar(32) NOT
NULL,
`youtube` varchar(100) NOT NULL,
`verified` enum('0','1') NOT
NULL DEFAULT '0',
`active` enum('0','1') NOT NULL DEFAULT '0',
`registered` varchar(32) NOT NULL DEFAULT '0/0000'
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Pages_Invites`
--
CREATE TABLE IF NOT EXISTS
`Wo_Pages_Invites` (
`id` int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`inviter_id` int(11) NOT NULL,
`invited_id` int(11) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Pages_Likes`
--
CREATE TABLE IF NOT EXISTS
`Wo_Pages_Likes` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`time` int(11) NOT NULL,
`active`
enum('0','1') NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_PinnedPosts`
--
CREATE TABLE IF NOT EXISTS
`Wo_PinnedPosts` (
`id` int(11) NOT NULL,
`user_id` int(255) NOT NULL,
`page_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`post_id`
int(255) NOT NULL,
`active` enum('0','1') NOT NULL DEFAULT '1'
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Posts`
--
CREATE TABLE IF NOT EXISTS `Wo_Posts`
(
`id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`user_id` int(11)
NOT NULL,
`recipient_id` int(11) NOT NULL,
`postText` text NOT NULL,
`page_id` int(11) NOT NULL,
`group_id` int(11) NOT NULL,
`postLink`
varchar(100) NOT NULL,
`postLinkTitle` varchar(100) NOT NULL,
`postLinkImage` varchar(100) NOT NULL,
`postLinkContent` varchar(100) NOT
NULL,
`postVimeo` varchar(100) NOT NULL,
`postDailymotion` varchar(100)
NOT NULL,
`postFacebook` varchar(100) NOT NULL,
`postFile` varchar(255)
CHARACTER SET latin1 NOT NULL,
`postFileName` varchar(200) NOT NULL,
`postYoutube` varchar(255) CHARACTER SET latin1 NOT NULL,
`postVine`
varchar(32) NOT NULL,
`postSoundCloud` varchar(255) CHARACTER SET latin1
NOT NULL,
`postMap` varchar(255) NOT NULL,
`postShare` int(11) NOT
NULL,
`postPrivacy` enum('0','1','2','3') NOT NULL DEFAULT '1',
`postType` varchar(30) NOT NULL,
`postFeeling` varchar(255) NOT NULL,
`postListening` varchar(255) NOT NULL,
`postTraveling` varchar(255) NOT
NULL,
`postWatching` varchar(255) NOT NULL,
`postPlaying` varchar(255)
NOT NULL,
`time` int(255) NOT NULL,
`registered` varchar(32) NOT NULL
DEFAULT '0/0000',
`album_name` varchar(52) NOT NULL,
`multi_image`
enum('0','1') NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT
CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_RecentSearches`
--
CREATE TABLE IF NOT EXISTS
`Wo_RecentSearches` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`search_id` int(11) NOT NULL,
`search_type` varchar(32) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Reports`
--
CREATE TABLE IF NOT EXISTS
`Wo_Reports` (
`id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`seen` int(11) NOT NULL DEFAULT '0',
`time`
int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_SavedPosts`
--
CREATE TABLE IF NOT EXISTS
`Wo_SavedPosts` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Tokens`
--
CREATE TABLE IF NOT EXISTS `Wo_Tokens`
(
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`app_id` int(11)
NOT NULL,
`token` varchar(200) NOT NULL,
`time` int(32) NOT NULL
)
ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Users`
--
CREATE TABLE IF NOT EXISTS `Wo_Users`
(
`user_id` int(11) NOT NULL,
`username` varchar(32) NOT NULL,
`email`
varchar(255) NOT NULL,
`password` varchar(32) NOT NULL,
`first_name`
varchar(32) NOT NULL,
`last_name` varchar(32) NOT NULL,
`avatar`
varchar(100) NOT NULL DEFAULT 'upload/photos/d-avatar.jpg',
`cover`
varchar(100) NOT NULL DEFAULT 'upload/photos/d-cover.jpg',
`background_image` varchar(100) NOT NULL,
`background_image_status`
enum('0','1') NOT NULL,
`relationship_id` int(11) NOT NULL,
`address`
varchar(100) NOT NULL,
`working` varchar(32) NOT NULL,
`working_link`
varchar(32) NOT NULL,
`about` text NOT NULL,
`school` varchar(32) NOT
NULL,
`gender` varchar(32) NOT NULL DEFAULT 'male',
`birthday` date NOT
NULL DEFAULT '0000-00-00',
`country_id` int(11) NOT NULL DEFAULT '1',
`website` varchar(50) NOT NULL,
`facebook` varchar(50) NOT NULL,
`google` varchar(50) NOT NULL,
`twitter` varchar(50) NOT NULL,
`linkedin` varchar(32) NOT NULL,
`vk` varchar(32) NOT NULL,
`instagram`
varchar(32) NOT NULL,
`language` varchar(31) NOT NULL,
`email_code`
varchar(32) NOT NULL,
`src` varchar(32) NOT NULL DEFAULT 'Undefined',
`ip_address` varchar(32) NOT NULL,
`follow_privacy` enum('1','0') NOT
NULL DEFAULT '0',
`post_privacy` varchar(255) NOT NULL DEFAULT
'ifollow',
`message_privacy` enum('1','0') NOT NULL DEFAULT '0',
`confirm_followers` enum('1','0') NOT NULL DEFAULT '0',
`show_activities_privacy` enum('0','1') NOT NULL DEFAULT '1',
`birth_privacy` enum('0','1','2') NOT NULL DEFAULT '0',
`visit_privacy`
enum('0','1') NOT NULL DEFAULT '0',
`verified` enum('1','0') NOT NULL
DEFAULT '0',
`lastseen` int(32) NOT NULL DEFAULT '0',
`showlastseen`
enum('1','0') NOT NULL DEFAULT '1',
`emailNotification` enum('1','0') NOT
NULL DEFAULT '1',
`e_liked` enum('0','1') NOT NULL DEFAULT '1',
`e_wondered` enum('0','1') NOT NULL DEFAULT '1',
`e_shared` enum('0','1')
NOT NULL DEFAULT '1',
`e_followed` enum('0','1') NOT NULL DEFAULT '1',
`e_commented` enum('0','1') NOT NULL DEFAULT '1',
`e_visited`
enum('0','1') NOT NULL DEFAULT '1',
`e_liked_page` enum('0','1') NOT NULL
DEFAULT '1',
`e_mentioned` enum('0','1') NOT NULL DEFAULT '1',
`e_joined_group` enum('0','1') NOT NULL DEFAULT '1',
`e_accepted`
enum('0','1') NOT NULL DEFAULT '1',
`e_profile_wall_post` enum('0','1')
NOT NULL DEFAULT '1',
`status` enum('1','0') NOT NULL DEFAULT '0',
`active` enum('0','1','2') NOT NULL DEFAULT '0',
`admin` enum('0','1')
NOT NULL DEFAULT '0',
`type` varchar(11) NOT NULL DEFAULT 'user',
`registered` varchar(32) NOT NULL DEFAULT '0/0000'
) ENGINE=InnoDB
AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
--
-- Dumping data for table
`Wo_Users`
--
INSERT INTO `Wo_Users` (`user_id`, `username`, `email`,
`password`, `first_name`, `last_name`, `avatar`, `cover`,
`background_image`, `background_image_status`, `relationship_id`,
`address`, `working`, `working_link`, `about`, `school`, `gender`,
`birthday`, `country_id`, `website`, `facebook`, `google`, `twitter`,
`linkedin`, `vk`, `instagram`, `language`, `email_code`, `src`,
`ip_address`, `follow_privacy`, `post_privacy`, `message_privacy`,
`confirm_followers`, `show_activities_privacy`, `birth_privacy`,
`visit_privacy`, `verified`, `lastseen`, `showlastseen`,
`emailNotification`, `e_liked`, `e_wondered`, `e_shared`, `e_followed`,
`e_commented`, `e_visited`, `e_liked_page`, `e_mentioned`,
`e_joined_group`, `e_accepted`, `e_profile_wall_post`, `status`, `active`,
`admin`, `type`, `registered`) VALUES
(1, 'admin', 'info@example.com',
'25d55ad283aa400af464c76d713c07ad', '', '', 'upload/photos/d-avatar.jpg',
'upload/photos/d-cover.jpg', '', '0', 0, '', '', '', '', '', 'male',
'0000-00-00', 1, '', '', '', '', '', '', '', '', '', 'Site', '', '0',
'ifollow', '0', '0', '1', '0', '0', '1', 0, '1', '1', '1', '1', '1', '1',
'1', '1', '1', '1', '1', '1', '1', '0', '1', '1', 'user', '0/0000');
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Verification_Requests`
--
CREATE TABLE IF NOT
EXISTS `Wo_Verification_Requests` (
`id` int(11) NOT NULL,
`user_id`
int(11) NOT NULL,
`page_id` int(11) NOT NULL,
`type` varchar(32) NOT
NULL,
`seen` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
--------------------------------------------------------
--
-- Table
structure for table `Wo_Wonders`
--
CREATE TABLE IF NOT EXISTS
`Wo_Wonders` (
`id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`post_id` int(11) NOT NULL,
`type` int(11) NOT NULL DEFAULT '0'
)
ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Indexes for dumped
tables
--
--
-- Indexes for table `Wo_Activities`
--
ALTER TABLE
`Wo_Activities`
ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD
KEY `post_id` (`post_id`), ADD KEY `activity_type`
(`activity_type`);
--
-- Indexes for table `Wo_Ads`
--
ALTER TABLE
`Wo_Ads`
ADD PRIMARY KEY (`id`), ADD KEY `active` (`active`), ADD KEY
`type` (`type`);
--
-- Indexes for table `Wo_Albums_Media`
--
ALTER TABLE
`Wo_Albums_Media`
ADD PRIMARY KEY (`id`), ADD KEY `post_id`
(`post_id`);
--
-- Indexes for table `Wo_Announcement`
--
ALTER TABLE
`Wo_Announcement`
ADD PRIMARY KEY (`id`), ADD KEY `active`
(`active`);
--
-- Indexes for table `Wo_Announcement_Views`
--
ALTER TABLE
`Wo_Announcement_Views`
ADD PRIMARY KEY (`id`), ADD KEY `user_id`
(`user_id`), ADD KEY `announcement_id` (`announcement_id`);
--
-- Indexes
for table `Wo_Apps`
--
ALTER TABLE `Wo_Apps`
ADD PRIMARY KEY
(`id`);
--
-- Indexes for table `Wo_Apps_Permission`
--
ALTER TABLE
`Wo_Apps_Permission`
ADD PRIMARY KEY (`id`), ADD KEY `user_id`
(`user_id`,`app_id`);
--
-- Indexes for table `Wo_Banned_Ip`
--
ALTER
TABLE `Wo_Banned_Ip`
ADD PRIMARY KEY (`id`), ADD KEY `ip_address`
(`ip_address`);
--
-- Indexes for table `Wo_Blocks`
--
ALTER TABLE
`Wo_Blocks`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table
`Wo_CommentLikes`
--
ALTER TABLE `Wo_CommentLikes`
ADD PRIMARY KEY (`id`),
ADD KEY `user_id` (`user_id`), ADD KEY `comment_id` (`comment_id`), ADD KEY
`post_id` (`post_id`);
--
-- Indexes for table `Wo_Comments`
--
ALTER
TABLE `Wo_Comments`
ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`),
ADD KEY `user_id` (`user_id`), ADD KEY `page_id` (`page_id`);
--
--
Indexes for table `Wo_CommentWonders`
--
ALTER TABLE `Wo_CommentWonders`
ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD KEY `comment_id`
(`comment_id`), ADD KEY `user_id` (`user_id`);
--
-- Indexes for table
`Wo_Comment_Replies`
--
ALTER TABLE `Wo_Comment_Replies`
ADD PRIMARY KEY
(`id`), ADD KEY `comment_id` (`comment_id`), ADD KEY `user_id`
(`user_id`,`page_id`);
--
-- Indexes for table
`Wo_Comment_Replies_Wonders`
--
ALTER TABLE `Wo_Comment_Replies_Wonders`
ADD PRIMARY KEY (`id`), ADD KEY `reply_id` (`reply_id`,`user_id`);
--
--
Indexes for table `Wo_Config`
--
ALTER TABLE `Wo_Config`
ADD PRIMARY KEY
(`id`);
--
-- Indexes for table `Wo_Followers`
--
ALTER TABLE
`Wo_Followers`
ADD PRIMARY KEY (`id`), ADD KEY `following_id`
(`following_id`), ADD KEY `follower_id` (`follower_id`), ADD KEY `active`
(`active`);
--
-- Indexes for table `Wo_Games`
--
ALTER TABLE `Wo_Games`
ADD PRIMARY KEY (`id`), ADD KEY `active` (`active`);
--
-- Indexes for
table `Wo_Games_Players`
--
ALTER TABLE `Wo_Games_Players`
ADD PRIMARY KEY
(`id`), ADD KEY `user_id` (`user_id`,`game_id`,`active`);
--
-- Indexes
for table `Wo_Groups`
--
ALTER TABLE `Wo_Groups`
ADD PRIMARY KEY (`id`),
ADD KEY `user_id` (`user_id`), ADD KEY `privacy` (`privacy`);
--
--
Indexes for table `Wo_Group_Members`
--
ALTER TABLE `Wo_Group_Members`
ADD
PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`,`group_id`);
--
--
Indexes for table `Wo_Hashtags`
--
ALTER TABLE `Wo_Hashtags`
ADD PRIMARY
KEY (`id`), ADD KEY `last_trend_time` (`last_trend_time`), ADD KEY
`trend_use_num` (`trend_use_num`), ADD KEY `tag` (`tag`);
--
-- Indexes
for table `Wo_Likes`
--
ALTER TABLE `Wo_Likes`
ADD PRIMARY KEY (`id`), ADD
KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`);
--
-- Indexes
for table `Wo_Messages`
--
ALTER TABLE `Wo_Messages`
ADD PRIMARY KEY
(`id`), ADD KEY `from_id` (`from_id`), ADD KEY `to_id` (`to_id`), ADD KEY
`seen` (`seen`);
--
-- Indexes for table `Wo_Notifications`
--
ALTER TABLE
`Wo_Notifications`
ADD PRIMARY KEY (`id`), ADD KEY `notifier_id`
(`notifier_id`), ADD KEY `user_id` (`recipient_id`), ADD KEY `post_id`
(`post_id`), ADD KEY `seen` (`seen`), ADD KEY `time` (`time`), ADD KEY
`page_id` (`page_id`), ADD KEY `group_id` (`group_id`,`seen_pop`);
--
--
Indexes for table `Wo_Pages`
--
ALTER TABLE `Wo_Pages`
ADD PRIMARY KEY
(`page_id`), ADD KEY `page_id` (`page_id`,`page_category`), ADD KEY
`registered` (`registered`), ADD KEY `user_id`
(`user_id`,`page_name`,`verified`,`active`);
--
-- Indexes for table
`Wo_Pages_Invites`
--
ALTER TABLE `Wo_Pages_Invites`
ADD PRIMARY KEY
(`id`), ADD KEY `page_id` (`page_id`,`inviter_id`,`invited_id`);
--
--
Indexes for table `Wo_Pages_Likes`
--
ALTER TABLE `Wo_Pages_Likes`
ADD
PRIMARY KEY (`id`), ADD KEY `id` (`id`,`user_id`,`page_id`), ADD KEY
`active` (`active`);
--
-- Indexes for table `Wo_PinnedPosts`
--
ALTER
TABLE `Wo_PinnedPosts`
ADD PRIMARY KEY (`id`), ADD KEY `user_id`
(`user_id`), ADD KEY `post_id` (`post_id`), ADD KEY `active` (`active`),
ADD KEY `page_id` (`page_id`), ADD KEY `group_id` (`group_id`);
--
--
Indexes for table `Wo_Posts`
--
ALTER TABLE `Wo_Posts`
ADD PRIMARY KEY
(`id`), ADD KEY `post_id` (`post_id`), ADD KEY `user_id` (`user_id`), ADD
KEY `recipient_id` (`recipient_id`), ADD KEY `postFile` (`postFile`), ADD
KEY `postShare` (`postShare`), ADD KEY `postType` (`postType`), ADD KEY
`postYoutube` (`postYoutube`), ADD KEY `page_id` (`page_id`), ADD KEY
`group_id` (`group_id`), ADD KEY `registered` (`registered`);
--
--
Indexes for table `Wo_RecentSearches`
--
ALTER TABLE `Wo_RecentSearches`
ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`,`search_id`), ADD KEY
`search_type` (`search_type`);
--
-- Indexes for table
`Wo_Reports`
--
ALTER TABLE `Wo_Reports`
ADD PRIMARY KEY (`id`), ADD KEY
`user_id` (`user_id`), ADD KEY `post_id` (`post_id`), ADD KEY `seen`
(`seen`);
--
-- Indexes for table `Wo_SavedPosts`
--
ALTER TABLE
`Wo_SavedPosts`
ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD
KEY `user_id` (`user_id`);
--
-- Indexes for table `Wo_Tokens`
--
ALTER
TABLE `Wo_Tokens`
ADD PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`),
ADD KEY `user_id_2` (`user_id`), ADD KEY `app_id` (`app_id`);
--
--
Indexes for table `Wo_Users`
--
ALTER TABLE `Wo_Users`
ADD PRIMARY KEY
(`user_id`), ADD UNIQUE KEY `username` (`username`), ADD UNIQUE KEY `email`
(`email`), ADD KEY `active` (`active`), ADD KEY `admin` (`admin`), ADD KEY
`src` (`src`), ADD KEY `gender` (`gender`), ADD KEY `avatar` (`avatar`),
ADD KEY `first_name` (`first_name`), ADD KEY `last_name` (`last_name`), ADD
KEY `registered` (`registered`);
--
-- Indexes for table
`Wo_Verification_Requests`
--
ALTER TABLE `Wo_Verification_Requests`
ADD
PRIMARY KEY (`id`), ADD KEY `user_id` (`user_id`), ADD KEY `page_id`
(`page_id`);
--
-- Indexes for table `Wo_Wonders`
--
ALTER TABLE
`Wo_Wonders`
ADD PRIMARY KEY (`id`), ADD KEY `post_id` (`post_id`), ADD
KEY `user_id` (`user_id`);
--
-- AUTO_INCREMENT for dumped
tables
--
--
-- AUTO_INCREMENT for table `Wo_Activities`
--
ALTER TABLE
`Wo_Activities`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Ads`
--
ALTER TABLE `Wo_Ads`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT,AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for
table `Wo_Albums_Media`
--
ALTER TABLE `Wo_Albums_Media`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Announcement`
--
ALTER TABLE `Wo_Announcement`
MODIFY `id` int(11) NOT
NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Announcement_Views`
--
ALTER TABLE `Wo_Announcement_Views`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Apps`
--
ALTER TABLE `Wo_Apps`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Apps_Permission`
--
ALTER TABLE `Wo_Apps_Permission`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Banned_Ip`
--
ALTER TABLE `Wo_Banned_Ip`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_Blocks`
--
ALTER TABLE
`Wo_Blocks`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_CommentLikes`
--
ALTER TABLE
`Wo_CommentLikes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Comments`
--
ALTER TABLE `Wo_Comments`
MODIFY
`id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_CommentWonders`
--
ALTER TABLE `Wo_CommentWonders`
MODIFY `id` int(11)
NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Comment_Replies`
--
ALTER TABLE `Wo_Comment_Replies`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Comment_Replies_Wonders`
--
ALTER TABLE
`Wo_Comment_Replies_Wonders`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_Config`
--
ALTER TABLE
`Wo_Config`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=67;
--
-- AUTO_INCREMENT for table
`Wo_Followers`
--
ALTER TABLE `Wo_Followers`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_Games`
--
ALTER TABLE
`Wo_Games`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Games_Players`
--
ALTER TABLE
`Wo_Games_Players`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Groups`
--
ALTER TABLE `Wo_Groups`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Group_Members`
--
ALTER TABLE `Wo_Group_Members`
MODIFY `id` int(11)
NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Hashtags`
--
ALTER TABLE `Wo_Hashtags`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_Likes`
--
ALTER TABLE
`Wo_Likes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Messages`
--
ALTER TABLE `Wo_Messages`
MODIFY
`id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Notifications`
--
ALTER TABLE `Wo_Notifications`
MODIFY `id` int(255)
NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_Pages`
--
ALTER
TABLE `Wo_Pages`
MODIFY `page_id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Pages_Invites`
--
ALTER TABLE
`Wo_Pages_Invites`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Pages_Likes`
--
ALTER TABLE
`Wo_Pages_Likes`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_PinnedPosts`
--
ALTER TABLE
`Wo_PinnedPosts`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Posts`
--
ALTER TABLE `Wo_Posts`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_RecentSearches`
--
ALTER TABLE `Wo_RecentSearches`
MODIFY `id` int(11)
NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Reports`
--
ALTER TABLE `Wo_Reports`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `Wo_SavedPosts`
--
ALTER
TABLE `Wo_SavedPosts`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
--
AUTO_INCREMENT for table `Wo_Tokens`
--
ALTER TABLE `Wo_Tokens`
MODIFY `id`
int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Users`
--
ALTER TABLE `Wo_Users`
MODIFY `user_id` int(11) NOT NULL
AUTO_INCREMENT,AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table
`Wo_Verification_Requests`
--
ALTER TABLE `Wo_Verification_Requests`
MODIFY
`id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table
`Wo_Wonders`
--
ALTER TABLE `Wo_Wonders`
MODIFY `id` int(11) NOT NULL
AUTO_INCREMENT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT
*/;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS
*/;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;